Editing Nonclustered Index General

Type
Choose the index type: Nonclustered, Clustered, XML or Spatial

Unique
A unique index is one in which no two rows are permitted to have the same index key value.

Table/View
Choose to create a table index or a view index.

Table Name or View Name
Select a table or a view.

Fields
Select the column or columns on which the index is based and the sorting order.

Included Columns
Select the non-key columns to be added to the leaf level of the nonclustered index.

Note: Support from SQL Server 2005 or later and SQL Azure.